Pandas Profiling Report

Dataset statistics

Number of variables	27
Number of observations	2719136
Missing cells	941627
Missing cells (%)	1.3%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	2.9 GiB
Average record size in memory	1.1 KiB

Variable types

Categorical	14
Numeric	12
Boolean	1

Alerts

`Category` has constant value "DRUGS"	Constant
`SpecialisationName` has a high cardinality: 95 distinct values	High cardinality
`BillNo` has a high cardinality: 1099192 distinct values	High cardinality
`BillDate` has a high cardinality: 1527 distinct values	High cardinality
`ItemName` has a high cardinality: 4364 distinct values	High cardinality
`Item_Code` has a high cardinality: 4223 distinct values	High cardinality
`GenericName` has a high cardinality: 2962 distinct values	High cardinality
`UHID` is highly overall correlated with `Bill_Year`	High correlation
`TQty` is highly overall correlated with `ReturnMRP`	High correlation
`UCPwithoutGST` is highly overall correlated with `MRP` and 2 other fields	High correlation
`PurGSTPer` is highly overall correlated with `TotalDiscount`	High correlation
`MRP` is highly overall correlated with `UCPwithoutGST` and 2 other fields	High correlation
`TotalCost` is highly overall correlated with `UCPwithoutGST` and 2 other fields	High correlation
`TotalDiscount` is highly overall correlated with `PurGSTPer`	High correlation
`NetSales` is highly overall correlated with `UCPwithoutGST` and 3 other fields	High correlation
`ReturnMRP` is highly overall correlated with `TQty` and 1 other fields	High correlation
`Bill_Month` is highly overall correlated with `Bill_Week`	High correlation
`Bill_Week` is highly overall correlated with `Bill_Month`	High correlation
`SalesType` is highly overall correlated with `PharmacyType`	High correlation
`PharmacyType` is highly overall correlated with `SalesType` and 1 other fields	High correlation
`Department` is highly overall correlated with `PharmacyType`	High correlation
`IsFormulary` is highly overall correlated with `Formulary`	High correlation
`Formulary` is highly overall correlated with `IsFormulary`	High correlation
`Bill_Year` is highly overall correlated with `UHID`	High correlation
`SalesType` is highly imbalanced (50.7%)	Imbalance
`Department` is highly imbalanced (73.6%)	Imbalance
`IsFormulary` is highly imbalanced (51.3%)	Imbalance
`Formulary` is highly imbalanced (61.0%)	Imbalance
`SubCategory` is highly imbalanced (53.9%)	Imbalance
`UHID` has 156637 (5.8%) missing values	Missing
`Department` has 442465 (16.3%) missing values	Missing
`Formulary` has 332707 (12.2%) missing values	Missing
`UCPwithoutGST` is highly skewed (γ1 = 63.87752404)	Skewed
`MRP` is highly skewed (γ1 = 50.22161308)	Skewed
`TotalCost` is highly skewed (γ1 = 39.50248905)	Skewed
`TotalDiscount` is highly skewed (γ1 = 285.8811301)	Skewed
`NetSales` is highly skewed (γ1 = 31.18778957)	Skewed
`ReturnMRP` is highly skewed (γ1 = 42.28664228)	Skewed
`PurGSTPer` has 2105336 (77.4%) zeros	Zeros
`TotalDiscount` has 2321505 (85.4%) zeros	Zeros
`NetSales` has 269495 (9.9%) zeros	Zeros
`ReturnMRP` has 2450236 (90.1%) zeros	Zeros

Reproduction

Analysis started	2023-05-08 13:34:48.098751
Analysis finished	2023-05-08 13:39:10.250625
Duration	4 minutes and 22.15 seconds
Software version	pandas-profiling v3.6.6
Download configuration	config.json

SalesType
Categorical

HIGH CORRELATION IMBALANCE

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	197.1 MiB

IP Dispense	1843450
OTC Dispense	576578
IP Return	261364
OP Dispense	30203
OTC Return	7347

Length

Max length	12
Median length	11
Mean length	11.016959
Min length	9

Characters and Unicode

Total characters	29956611
Distinct characters	16
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	IP Dispense
2nd row	IP Dispense
3rd row	IP Dispense
4th row	IP Dispense
5th row	IP Dispense

Common Values

Value	Count	Frequency (%)
IP Dispense	1843450	67.8%
OTC Dispense	576578	21.2%
IP Return	261364	9.6%
OP Dispense	30203	1.1%
OTC Return	7347	0.3%
OP Return	194	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
dispense	2450231	45.1%
ip	2104814	38.7%
otc	583925	10.7%
return	268905	4.9%
op	30397	0.6%

Most occurring characters

Value	Count	Frequency (%)
e	5169367	17.3%
s	4900462	16.4%
	2719136	9.1%
n	2719136	9.1%
D	2450231	8.2%
i	2450231	8.2%
p	2450231	8.2%
P	2135211	7.1%
I	2104814	7.0%
O	614322	2.1%
Other values (6)	2243470	7.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	18496142	61.7%
Uppercase Letter	8741333	29.2%
Space Separator	2719136	9.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	5169367	27.9%
s	4900462	26.5%
n	2719136	14.7%
i	2450231	13.2%
p	2450231	13.2%
t	268905	1.5%
u	268905	1.5%
r	268905	1.5%

Uppercase Letter

Value	Count	Frequency (%)
D	2450231	28.0%
P	2135211	24.4%
I	2104814	24.1%
O	614322	7.0%
T	583925	6.7%
C	583925	6.7%
R	268905	3.1%

Space Separator

Value	Count	Frequency (%)
	2719136	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	27237475	90.9%
Common	2719136	9.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	5169367	19.0%
s	4900462	18.0%
n	2719136	10.0%
D	2450231	9.0%
i	2450231	9.0%
p	2450231	9.0%
P	2135211	7.8%
I	2104814	7.7%
O	614322	2.3%
T	583925	2.1%
Other values (5)	1659545	6.1%

Common

Value	Count	Frequency (%)
	2719136	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	29956611	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	5169367	17.3%
s	4900462	16.4%
	2719136	9.1%
n	2719136	9.1%
D	2450231	8.2%
i	2450231	8.2%
p	2450231	8.2%
P	2135211	7.1%
I	2104814	7.0%
O	614322	2.1%
Other values (6)	2243470	7.5%

UHID
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	58130
Distinct (%)	2.3%
Missing	156637
Missing (%)	5.8%
Infinite	0
Infinite (%)	0.0%
Mean	1.2018057 × 10¹⁰

Minimum	1.2018 × 10¹⁰
Maximum	1.2018136 × 10¹⁰
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	41.5 MiB

Quantile statistics

Minimum	1.2018 × 10¹⁰
5-th percentile	1.2018003 × 10¹⁰
Q1	1.2018022 × 10¹⁰
median	1.2018052 × 10¹⁰
Q3	1.2018089 × 10¹⁰
95-th percentile	1.2018123 × 10¹⁰
Maximum	1.2018136 × 10¹⁰
Range	135522
Interquartile range (IQR)	67741

Descriptive statistics

Standard deviation	38728.754
Coefficient of variation (CV)	3.2225471 × 10^-6
Kurtosis	-1.1398444
Mean	1.2018057 × 10¹⁰
Median Absolute Deviation (MAD)	33026
Skewness	0.26990207
Sum	3.0796258 × 10¹⁶
Variance	1.4999164 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.201806711 × 10¹⁰	3556	0.1%
1.201800818 × 10¹⁰	3356	0.1%
1.20180057 × 10¹⁰	3066	0.1%
1.201801635 × 10¹⁰	2416	0.1%
1.201807952 × 10¹⁰	2311	0.1%
1.201808741 × 10¹⁰	2306	0.1%
1.201807345 × 10¹⁰	2228	0.1%
1.201804314 × 10¹⁰	2195	0.1%
1.201810332 × 10¹⁰	2149	0.1%
1.201800347 × 10¹⁰	2149	0.1%
Other values (58120)	2536767	93.3%
(Missing)	156637	5.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.2018 × 10¹⁰	7	< 0.1%
1.2018 × 10¹⁰	15	< 0.1%
1.2018 × 10¹⁰	8	< 0.1%
1.2018 × 10¹⁰	11	< 0.1%
1.201800001 × 10¹⁰	3	< 0.1%
1.201800001 × 10¹⁰	6	< 0.1%
1.201800001 × 10¹⁰	4	< 0.1%
1.201800001 × 10¹⁰	4	< 0.1%
1.201800001 × 10¹⁰	185	< 0.1%
1.201800001 × 10¹⁰	74	< 0.1%

Value	Count	Frequency (%)
1.201813552 × 10¹⁰	2	< 0.1%
1.201813552 × 10¹⁰	3	< 0.1%
1.201813552 × 10¹⁰	2	< 0.1%
1.201813552 × 10¹⁰	5	< 0.1%
1.201813552 × 10¹⁰	11	< 0.1%
1.201813552 × 10¹⁰	7	< 0.1%
1.201813552 × 10¹⁰	8	< 0.1%
1.201813551 × 10¹⁰	1	< 0.1%
1.201813551 × 10¹⁰	8	< 0.1%
1.201813551 × 10¹⁰	4	< 0.1%

PharmacyType
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	173.9 MiB

IP	2104814
OP	430077
OTC	184245

Length

Max length	3
Median length	2
Mean length	2.0677587
Min length	2

Characters and Unicode

Total characters	5622517
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	IP
2nd row	IP
3rd row	IP
4th row	IP
5th row	IP

Common Values

Value	Count	Frequency (%)
IP	2104814	77.4%
OP	430077	15.8%
OTC	184245	6.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
ip	2104814	77.4%
op	430077	15.8%
otc	184245	6.8%

Most occurring characters

Value	Count	Frequency (%)
P	2534891	45.1%
I	2104814	37.4%
O	614322	10.9%
T	184245	3.3%
C	184245	3.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	5622517	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
P	2534891	45.1%
I	2104814	37.4%
O	614322	10.9%
T	184245	3.3%
C	184245	3.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	5622517	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
P	2534891	45.1%
I	2104814	37.4%
O	614322	10.9%
T	184245	3.3%
C	184245	3.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5622517	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
P	2534891	45.1%
I	2104814	37.4%
O	614322	10.9%
T	184245	3.3%
C	184245	3.3%

SpecialisationName
Categorical

Distinct	95
Distinct (%)	< 0.1%
Missing	50
Missing (%)	< 0.1%
Memory size	224.5 MiB

Liver Disease and Transplantation	667071
Hepatology	413521
Covid Care Team	248655
Internal Medicine and Diabetology	156780
Cardiology	93219
Other values (90)	1139840

Length

Max length	62
Median length	53
Mean length	21.283485
Min length	4

Characters and Unicode

Total characters	57871626
Distinct characters	51
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	Liver Disease and Transplantation
2nd row	Liver Disease and Transplantation
3rd row	Liver Disease and Transplantation
4th row	Liver Disease and Transplantation
5th row	Liver Disease and Transplantation

Common Values

Value	Count	Frequency (%)
Liver Disease and Transplantation	667071	24.5%
Hepatology	413521	15.2%
Covid Care Team	248655	9.1%
Internal Medicine and Diabetology	156780	5.8%
Cardiology	93219	3.4%
Emergency Medicine	90025	3.3%
Obstetrics & Gynaecology	80036	2.9%
Medical Oncology	79547	2.9%
Neurosurgery	72738	2.7%
Pediatric Hemato Oncology	71929	2.6%
Other values (85)	745565	27.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
and	950749	13.4%
transplantation	706016	10.0%
liver	697700	9.9%
disease	672651	9.5%
hepatology	481559	6.8%
medicine	347003	4.9%
care	296137	4.2%
covid	248655	3.5%
team	248655	3.5%
internal	204067	2.9%
Other values (106)	2218598	31.4%

Most occurring characters

Value	Count	Frequency (%)
a	6271926	10.8%
e	5744754	9.9%
n	4601010	8.0%
i	4355759	7.5%
	4352704	7.5%
o	4037067	7.0%
r	3359113	5.8%
t	3300373	5.7%
s	2651480	4.6%
l	2477952	4.3%
Other values (41)	16719488	28.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	47219035	81.6%
Uppercase Letter	6100200	10.5%
Space Separator	4352704	7.5%
Other Punctuation	181425	0.3%
Dash Punctuation	18248	< 0.1%
Open Punctuation	7	< 0.1%
Close Punctuation	7	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	6271926	13.3%
e	5744754	12.2%
n	4601010	9.7%
i	4355759	9.2%
o	4037067	8.5%
r	3359113	7.1%
t	3300373	7.0%
s	2651480	5.6%
l	2477952	5.2%
d	2095912	4.4%
Other values (13)	8323689	17.6%

Uppercase Letter

Value	Count	Frequency (%)
T	962103	15.8%
D	855870	14.0%
L	711566	11.7%
C	687503	11.3%
H	594065	9.7%
M	535945	8.8%
O	346557	5.7%
I	296662	4.9%
P	288564	4.7%
N	182141	3.0%
Other values (11)	639224	10.5%

Other Punctuation

Value	Count	Frequency (%)
&	159440	87.9%
,	21985	12.1%

Dash Punctuation

Value	Count	Frequency (%)
-	9350	51.2%
–	8898	48.8%

Space Separator

Value	Count	Frequency (%)
	4352704	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	7	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	7	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	53319235	92.1%
Common	4552391	7.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	6271926	11.8%
e	5744754	10.8%
n	4601010	8.6%
i	4355759	8.2%
o	4037067	7.6%
r	3359113	6.3%
t	3300373	6.2%
s	2651480	5.0%
l	2477952	4.6%
d	2095912	3.9%
Other values (34)	14423889	27.1%

Common

Value	Count	Frequency (%)
	4352704	95.6%
&	159440	3.5%
,	21985	0.5%
-	9350	0.2%
–	8898	0.2%
(	7	< 0.1%
)	7	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	57862728	> 99.9%
Punctuation	8898	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	6271926	10.8%
e	5744754	9.9%
n	4601010	8.0%
i	4355759	7.5%
	4352704	7.5%
o	4037067	7.0%
r	3359113	5.8%
t	3300373	5.7%
s	2651480	4.6%
l	2477952	4.3%
Other values (40)	16710590	28.9%

Punctuation

Value	Count	Frequency (%)
–	8898	100.0%

Department
Categorical

HIGH CORRELATION IMBALANCE MISSING

Distinct	12
Distinct (%)	< 0.1%
Missing	442465
Missing (%)	16.3%
Memory size	189.1 MiB

MS IP Pharmacy	1917738
SS OT Pharmacy	181524
New MS OP Pharmacy-GF	82630
SS ORAGADAM.	34088
SS Cath Lab Store	26049
Other values (7)	34642

Length

Max length	28
Median length	14
Mean length	14.331921
Min length	12

Characters and Unicode

Total characters	32629070
Distinct characters	38
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	MS IP Pharmacy
2nd row	MS IP Pharmacy
3rd row	MS IP Pharmacy
4th row	MS IP Pharmacy
5th row	MS IP Pharmacy

Common Values

Value	Count	Frequency (%)
MS IP Pharmacy	1917738	70.5%
SS OT Pharmacy	181524	6.7%
New MS OP Pharmacy-GF	82630	3.0%
SS ORAGADAM.	34088	1.3%
SS Cath Lab Store	26049	1.0%
New MS OP Pharmacy-2F	23958	0.9%
SS COVID STORE	9864	0.4%
SS OP VACCINE	781	< 0.1%
MS Flu ER Dispensing Counter	23	< 0.1%
MS OP Pharmacy-GF	9	< 0.1%
Other values (2)	7	< 0.1%
(Missing)	442465	16.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
pharmacy	2099262	30.3%
ms	2024365	29.2%
ip	1917740	27.7%
ss	252306	3.6%
ot	181524	2.6%
op	107383	1.5%
new	106588	1.5%
pharmacy-gf	82639	1.2%
store	35913	0.5%
oragadam	34088	0.5%
Other values (10)	86800	1.3%

Most occurring characters

Value	Count	Frequency (%)
	4651937	14.3%
a	4463830	13.7%
P	4230989	13.0%
S	2564890	7.9%
r	2231938	6.8%
h	2231915	6.8%
y	2205866	6.8%
c	2205866	6.8%
m	2205866	6.8%
M	2058453	6.3%
Other values (28)	3577520	11.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	15889074	48.7%
Uppercase Letter	11923406	36.5%
Space Separator	4651937	14.3%
Dash Punctuation	106602	0.3%
Other Punctuation	34088	0.1%
Decimal Number	23963	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	4463830	28.1%
r	2231938	14.0%
h	2231915	14.0%
y	2205866	13.9%
c	2205866	13.9%
m	2205866	13.9%
e	132683	0.8%
w	106588	0.7%
t	52121	0.3%
o	26074	0.2%
Other values (8)	26327	0.2%

Uppercase Letter

Value	Count	Frequency (%)
P	4230989	35.5%
S	2564890	21.5%
M	2058453	17.3%
I	1928385	16.2%
O	342723	2.9%
T	191388	1.6%
G	116727	1.0%
N	107369	0.9%
F	106625	0.9%
A	103045	0.9%
Other values (6)	172812	1.4%

Space Separator

Value	Count	Frequency (%)
	4651937	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	106602	100.0%

Other Punctuation

Value	Count	Frequency (%)
.	34088	100.0%

Decimal Number

Value	Count	Frequency (%)
2	23963	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	27812480	85.2%
Common	4816590	14.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	4463830	16.0%
P	4230989	15.2%
S	2564890	9.2%
r	2231938	8.0%
h	2231915	8.0%
y	2205866	7.9%
c	2205866	7.9%
m	2205866	7.9%
M	2058453	7.4%
I	1928385	6.9%
Other values (24)	1484482	5.3%

Common

Value	Count	Frequency (%)
	4651937	96.6%
-	106602	2.2%
.	34088	0.7%
2	23963	0.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	32629070	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	4651937	14.3%
a	4463830	13.7%
P	4230989	13.0%
S	2564890	7.9%
r	2231938	6.8%
h	2231915	6.8%
y	2205866	6.8%
c	2205866	6.8%
m	2205866	6.8%
M	2058453	6.3%
Other values (28)	3577520	11.0%

BillNo
Categorical

Distinct	1099192
Distinct (%)	40.4%
Missing	0
Missing (%)	0.0%
Memory size	199.4 MiB

OPPDS22-04858	190
OTCPDS22-04858	56
PDS21-141817	51
PDS20-164638	50
PDS21-51030	46
Other values (1099187)	2718743

Length

Max length	14
Median length	13
Mean length	11.891973
Min length	11

Characters and Unicode

Total characters	32335893
Distinct characters	19
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	597430 ?
Unique (%)	22.0%

Sample

1st row	PDS19-08659
2nd row	PDS19-08923
3rd row	PDS19-08981
4th row	PDS19-08981
5th row	PDS19-08981

Common Values

Value	Count	Frequency (%)
OPPDS22-04858	190	< 0.1%
OTCPDS22-04858	56	< 0.1%
PDS21-141817	51	< 0.1%
PDS20-164638	50	< 0.1%
PDS21-51030	46	< 0.1%
OPPDS21-10404	44	< 0.1%
PDS20-151216	43	< 0.1%
PDS20-136208	42	< 0.1%
PDS20-131943	42	< 0.1%
OTCPDS19-05176	42	< 0.1%
Other values (1099182)	2718530	> 99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
oppds22-04858	190	< 0.1%
otcpds22-04858	56	< 0.1%
pds21-141817	51	< 0.1%
pds20-164638	50	< 0.1%
pds21-51030	46	< 0.1%
oppds21-10404	44	< 0.1%
pds20-151216	43	< 0.1%
pds20-131943	42	< 0.1%
otcpds19-05176	42	< 0.1%
pds20-136208	42	< 0.1%
Other values (1099182)	2718530	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
2	4765257	14.7%
1	3665094	11.3%
P	2845832	8.8%
S	2719136	8.4%
-	2719136	8.4%
D	2450546	7.6%
0	1993691	6.2%
9	1748097	5.4%
3	1456931	4.5%
4	1374098	4.2%
Other values (9)	6598075	20.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	20123962	62.2%
Uppercase Letter	9492795	29.4%
Dash Punctuation	2719136	8.4%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	4765257	23.7%
1	3665094	18.2%
0	1993691	9.9%
9	1748097	8.7%
3	1456931	7.2%
4	1374098	6.8%
5	1322804	6.6%
6	1290330	6.4%
7	1257186	6.2%
8	1250474	6.2%

Uppercase Letter

Value	Count	Frequency (%)
P	2845832	30.0%
S	2719136	28.6%
D	2450546	25.8%
O	576891	6.1%
L	268590	2.8%
R	268590	2.8%
C	181605	1.9%
T	181605	1.9%

Dash Punctuation

Value	Count	Frequency (%)
-	2719136	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	22843098	70.6%
Latin	9492795	29.4%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	4765257	20.9%
1	3665094	16.0%
-	2719136	11.9%
0	1993691	8.7%
9	1748097	7.7%
3	1456931	6.4%
4	1374098	6.0%
5	1322804	5.8%
6	1290330	5.6%
7	1257186	5.5%

Latin

Value	Count	Frequency (%)
P	2845832	30.0%
S	2719136	28.6%
D	2450546	25.8%
O	576891	6.1%
L	268590	2.8%
R	268590	2.8%
C	181605	1.9%
T	181605	1.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	32335893	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	4765257	14.7%
1	3665094	11.3%
P	2845832	8.8%
S	2719136	8.4%
-	2719136	8.4%
D	2450546	7.6%
0	1993691	6.2%
9	1748097	5.4%
3	1456931	4.5%
4	1374098	4.2%
Other values (9)	6598075	20.4%

BillDate
Categorical

Distinct	1527
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	194.5 MiB

2022-12-20	3804
2023-02-15	3778
2023-02-03	3706
2023-02-24	3694
2023-02-07	3655
Other values (1522)	2700499

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	27191360
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2019-01-30
2nd row	2019-01-31
3rd row	2019-01-31
4th row	2019-01-31
5th row	2019-01-31

Common Values

Value	Count	Frequency (%)
2022-12-20	3804	0.1%
2023-02-15	3778	0.1%
2023-02-03	3706	0.1%
2023-02-24	3694	0.1%
2023-02-07	3655	0.1%
2023-03-01	3631	0.1%
2023-01-24	3595	0.1%
2023-02-16	3581	0.1%
2022-12-15	3561	0.1%
2023-03-04	3543	0.1%
Other values (1517)	2682588	98.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2022-12-20	3804	0.1%
2023-02-15	3778	0.1%
2023-02-03	3706	0.1%
2023-02-24	3694	0.1%
2023-02-07	3655	0.1%
2023-03-01	3631	0.1%
2023-01-24	3595	0.1%
2023-02-16	3581	0.1%
2022-12-15	3561	0.1%
2023-03-04	3543	0.1%
Other values (1517)	2682588	98.7%

Most occurring characters

Value	Count	Frequency (%)
2	7580107	27.9%
0	6486672	23.9%
-	5438272	20.0%
1	3587656	13.2%
9	918831	3.4%
3	820265	3.0%
8	487728	1.8%
5	475930	1.8%
7	469444	1.7%
4	466863	1.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	21753088	80.0%
Dash Punctuation	5438272	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	7580107	34.8%
0	6486672	29.8%
1	3587656	16.5%
9	918831	4.2%
3	820265	3.8%
8	487728	2.2%
5	475930	2.2%
7	469444	2.2%
4	466863	2.1%
6	459592	2.1%

Dash Punctuation

Value	Count	Frequency (%)
-	5438272	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	27191360	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	7580107	27.9%
0	6486672	23.9%
-	5438272	20.0%
1	3587656	13.2%
9	918831	3.4%
3	820265	3.0%
8	487728	1.8%
5	475930	1.8%
7	469444	1.7%
4	466863	1.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	27191360	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	7580107	27.9%
0	6486672	23.9%
-	5438272	20.0%
1	3587656	13.2%
9	918831	3.4%
3	820265	3.0%
8	487728	1.8%
5	475930	1.8%
7	469444	1.7%
4	466863	1.7%

ItemName
Categorical

Distinct	4364
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	280.6 MiB

SODIUM CHLORIDE 0.9% 100MLCLARIS	93660
EMESET (ONDANSETRON) 2ML INJ CIPLA	58981
KABILYTE (MULTIPLE ELECTROLYTES) 500ML FLEXBAG FRESENIUS	56517
WATER FOR INJECTION 10ML CLARIS	49640
SODIUM CHLORIDE 0.9% 500ML (UNIBAG ) CLARIS	42158
Other values (4359)	2418180

Length

Max length	186
Median length	118
Mean length	43.159531
Min length	12

Characters and Unicode

Total characters	117356635
Distinct characters	70
Distinct categories	11 ?
Distinct scripts	2 ?
Distinct blocks	3 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	241 ?
Unique (%)	< 0.1%

Sample

1st row	NEKSIUM (ESOMEPRAZOLE) 20MG TAB 1x10 PFIZER
2nd row	FENSTUD (FENTANYL) 50MCG/10ML INJ RUSAN
3rd row	CALCIUM GLUCONATE 10ML INJ 1X1 HINDU
4th row	CLOHEX MOUTH WASH 150ML DR REDDYS
5th row	DEXTROSE 5% 500ML CLARIS

Common Values

Value	Count	Frequency (%)
SODIUM CHLORIDE 0.9% 100MLCLARIS	93660	3.4%
EMESET (ONDANSETRON) 2ML INJ CIPLA	58981	2.2%
KABILYTE (MULTIPLE ELECTROLYTES) 500ML FLEXBAG FRESENIUS	56517	2.1%
WATER FOR INJECTION 10ML CLARIS	49640	1.8%
SODIUM CHLORIDE 0.9% 500ML (UNIBAG ) CLARIS	42158	1.6%
SODIUM CHLORIDE 0.9% 100ML FREEFLEX BAG FRESENIUS KABI	37437	1.4%
PANSEC (PANTOPRAZOLE) 40MG INJ CIPLA	33705	1.2%
LOX JELLY (LIGNOCAINE HYDROCHLORIDE) 2% 30GM GEL NEON	31712	1.2%
PARACIP (PARACETAMOL 1GM) 100ML IV INJ CIPLA	26982	1.0%
PARIDEM (PANTOPRAZOLE) 40MG INJ EMCURE	26763	1.0%
Other values (4354)	2261581	83.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
inj	1103097	6.4%
tab	541363	3.2%
	506197	2.9%
sodium	337340	2.0%
cipla	322268	1.9%
chloride	318692	1.9%
neon	291506	1.7%
1x10	284371	1.7%
0.9	258831	1.5%
100ml	237819	1.4%
Other values (5754)	12964845	75.5%

Most occurring characters

Value	Count	Frequency (%)
	14783213	12.6%
E	7878108	6.7%
A	7797036	6.6%
I	7659471	6.5%
L	6837224	5.8%
N	6283348	5.4%
O	5904127	5.0%
M	5846812	5.0%
R	4980870	4.2%
T	4676856	4.0%
Other values (60)	44709570	38.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	86695661	73.9%
Space Separator	14783839	12.6%
Decimal Number	9425188	8.0%
Open Punctuation	2170817	1.8%
Close Punctuation	2169438	1.8%
Other Punctuation	1130874	1.0%
Lowercase Letter	507917	0.4%
Math Symbol	407600	0.3%
Dash Punctuation	65252	0.1%
Connector Punctuation	31	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	7878108	9.1%
A	7797036	9.0%
I	7659471	8.8%
L	6837224	7.9%
N	6283348	7.2%
O	5904127	6.8%
M	5846812	6.7%
R	4980870	5.7%
T	4676856	5.4%
C	4159306	4.8%
Other values (17)	24672503	28.5%

Lowercase Letter

Value	Count	Frequency (%)
x	490326	96.5%
r	7663	1.5%
g	3415	0.7%
m	3370	0.7%
s	441	0.1%
c	321	0.1%
o	319	0.1%
e	319	0.1%
t	319	0.1%
f	319	0.1%
Other values (7)	1105	0.2%

Decimal Number

Value	Count	Frequency (%)
0	3745782	39.7%
1	2373015	25.2%
5	1390271	14.8%
2	738786	7.8%
4	443735	4.7%
9	274766	2.9%
3	258011	2.7%
6	124398	1.3%
7	48084	0.5%
8	28340	0.3%

Other Punctuation

Value	Count	Frequency (%)
.	576541	51.0%
%	436838	38.6%
/	104854	9.3%
&	9706	0.9%
,	2935	0.3%

Space Separator

Value	Count	Frequency (%)
	14783213	> 99.9%
	626	< 0.1%

Open Punctuation

Value	Count	Frequency (%)
(	2170810	> 99.9%
[	7	< 0.1%

Close Punctuation

Value	Count	Frequency (%)
)	2169431	> 99.9%
]	7	< 0.1%

Math Symbol

Value	Count	Frequency (%)
+	407589	> 99.9%
\|	11	< 0.1%

Dash Punctuation

Value	Count	Frequency (%)
-	65252	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	31	100.0%

Final Punctuation

Value	Count	Frequency (%)
’	18	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	87203578	74.3%
Common	30153057	25.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	7878108	9.0%
A	7797036	8.9%
I	7659471	8.8%
L	6837224	7.8%
N	6283348	7.2%
O	5904127	6.8%
M	5846812	6.7%
R	4980870	5.7%
T	4676856	5.4%
C	4159306	4.8%
Other values (34)	25180420	28.9%

Common

Value	Count	Frequency (%)
	14783213	49.0%
0	3745782	12.4%
1	2373015	7.9%
(	2170810	7.2%
)	2169431	7.2%
5	1390271	4.6%
2	738786	2.5%
.	576541	1.9%
4	443735	1.5%
%	436838	1.4%
Other values (16)	1324635	4.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	117355174	> 99.9%
None	1443	< 0.1%
Punctuation	18	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	14783213	12.6%
E	7878108	6.7%
A	7797036	6.6%
I	7659471	6.5%
L	6837224	5.8%
N	6283348	5.4%
O	5904127	5.0%
M	5846812	5.0%
R	4980870	4.2%
T	4676856	4.0%
Other values (57)	44708109	38.1%

None

Value	Count	Frequency (%)
Â	817	56.6%
	626	43.4%

Punctuation

Value	Count	Frequency (%)
’	18	100.0%

Item_Code
Categorical

Distinct	4223
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	189.3 MiB

PH000579	93660
PH000258	58981
PH000561	56517
PH000439	49640
PH000569	42158
Other values (4218)	2418180

Length

Max length	8
Median length	8
Mean length	8
Min length	8

Characters and Unicode

Total characters	21753088
Distinct characters	14
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	219 ?
Unique (%)	< 0.1%

Sample

1st row	PH001036
2nd row	PH001660
3rd row	PH000543
4th row	PH000604
5th row	PH000564

Common Values

Value	Count	Frequency (%)
PH000579	93660	3.4%
PH000258	58981	2.2%
PH000561	56517	2.1%
PH000439	49640	1.8%
PH000569	42158	1.6%
PH002839	37441	1.4%
PH000295	33705	1.2%
PH000208	31712	1.2%
PH000589	26982	1.0%
PH003917	26763	1.0%
Other values (4213)	2261577	83.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
ph000579	93660	3.4%
ph000258	58981	2.2%
ph000561	56517	2.1%
ph000439	49640	1.8%
ph000569	42158	1.6%
ph002839	37441	1.4%
ph000295	33705	1.2%
ph000208	31712	1.2%
ph000589	26982	1.0%
ph003917	26763	1.0%
Other values (4213)	2261577	83.2%

Most occurring characters

Value	Count	Frequency (%)
0	7757521	35.7%
P	2719123	12.5%
H	2719123	12.5%
1	1260130	5.8%
3	1112357	5.1%
5	1011620	4.7%
2	991764	4.6%
9	943591	4.3%
8	894900	4.1%
6	879765	4.0%
Other values (4)	1463194	6.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	16314816	75.0%
Uppercase Letter	5438272	25.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	7757521	47.5%
1	1260130	7.7%
3	1112357	6.8%
5	1011620	6.2%
2	991764	6.1%
9	943591	5.8%
8	894900	5.5%
6	879765	5.4%
4	747476	4.6%
7	715692	4.4%

Uppercase Letter

Value	Count	Frequency (%)
P	2719123	50.0%
H	2719123	50.0%
M	13	< 0.1%
C	13	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	16314816	75.0%
Latin	5438272	25.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	7757521	47.5%
1	1260130	7.7%
3	1112357	6.8%
5	1011620	6.2%
2	991764	6.1%
9	943591	5.8%
8	894900	5.5%
6	879765	5.4%
4	747476	4.6%
7	715692	4.4%

Latin

Value	Count	Frequency (%)
P	2719123	50.0%
H	2719123	50.0%
M	13	< 0.1%
C	13	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	21753088	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	7757521	35.7%
P	2719123	12.5%
H	2719123	12.5%
1	1260130	5.8%
3	1112357	5.1%
5	1011620	4.7%
2	991764	4.6%
9	943591	4.3%
8	894900	4.1%
6	879765	4.0%
Other values (4)	1463194	6.7%

IsFormulary
Boolean

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	23.3 MiB

True	2431846
False	287290

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
True	2431846	89.4%
False	287290	10.6%

Formulary
Categorical

HIGH CORRELATION IMBALANCE MISSING

Distinct	6
Distinct (%)	< 0.1%
Missing	332707
Missing (%)	12.2%
Memory size	165.7 MiB

P1	1811418
P2	474186
Innovator	72024
P3	16798
INNOVATOR	11418

Length

Max length	9
Median length	2
Mean length	2.2454919
Min length	2

Characters and Unicode

Total characters	5358707
Distinct characters	21
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	P1
2nd row	P2
3rd row	P1
4th row	P1
5th row	P1

Common Values

Value	Count	Frequency (%)
P1	1811418	66.6%
P2	474186	17.4%
Innovator	72024	2.6%
P3	16798	0.6%
INNOVATOR	11418	0.4%
198.5	585	< 0.1%
(Missing)	332707	12.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
p1	1811418	75.9%
p2	474186	19.9%
innovator	83442	3.5%
p3	16798	0.7%
198.5	585	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
P	2302402	43.0%
1	1812003	33.8%
2	474186	8.8%
n	144048	2.7%
o	144048	2.7%
I	83442	1.6%
v	72024	1.3%
a	72024	1.3%
t	72024	1.3%
r	72024	1.3%
Other values (11)	110482	2.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	2477188	46.2%
Decimal Number	2304742	43.0%
Lowercase Letter	576192	10.8%
Other Punctuation	585	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
P	2302402	92.9%
I	83442	3.4%
O	22836	0.9%
N	22836	0.9%
V	11418	0.5%
A	11418	0.5%
T	11418	0.5%
R	11418	0.5%

Decimal Number

Value	Count	Frequency (%)
1	1812003	78.6%
2	474186	20.6%
3	16798	0.7%
9	585	< 0.1%
8	585	< 0.1%
5	585	< 0.1%

Lowercase Letter

Value	Count	Frequency (%)
n	144048	25.0%
o	144048	25.0%
v	72024	12.5%
a	72024	12.5%
t	72024	12.5%
r	72024	12.5%

Other Punctuation

Value	Count	Frequency (%)
.	585	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3053380	57.0%
Common	2305327	43.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
P	2302402	75.4%
n	144048	4.7%
o	144048	4.7%
I	83442	2.7%
v	72024	2.4%
a	72024	2.4%
t	72024	2.4%
r	72024	2.4%
O	22836	0.7%
N	22836	0.7%
Other values (4)	45672	1.5%

Common

Value	Count	Frequency (%)
1	1812003	78.6%
2	474186	20.6%
3	16798	0.7%
9	585	< 0.1%
8	585	< 0.1%
.	585	< 0.1%
5	585	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5358707	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
P	2302402	43.0%
1	1812003	33.8%
2	474186	8.8%
n	144048	2.7%
o	144048	2.7%
I	83442	1.6%
v	72024	1.3%
a	72024	1.3%
t	72024	1.3%
r	72024	1.3%
Other values (11)	110482	2.1%

TQty
Real number (ℝ)

Distinct	271
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.4365423

Minimum	-450
Maximum	1250
Zeros	3
Zeros (%)	< 0.1%
Negative	268905
Negative (%)	9.9%
Memory size	41.5 MiB

Quantile statistics

Minimum	-450
5-th percentile	-2
Q1	1
median	1
Q3	2
95-th percentile	8
Maximum	1250
Range	1700
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	6.5954165
Coefficient of variation (CV)	2.7068754
Kurtosis	1164.0116
Mean	2.4365423
Median Absolute Deviation (MAD)	1
Skewness	16.816578
Sum	6625290
Variance	43.499519
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1266708	46.6%
2	524272	19.3%
3	220060	8.1%
4	143551	5.3%
-1	131909	4.9%
5	86702	3.2%
-2	70264	2.6%
6	56242	2.1%
10	43501	1.6%
-3	27657	1.0%
Other values (261)	148270	5.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-450	1	< 0.1%
-378	1	< 0.1%
-360	1	< 0.1%
-300	2	< 0.1%
-182	1	< 0.1%
-180	4	< 0.1%
-170	1	< 0.1%
-164	1	< 0.1%
-160	1	< 0.1%
-120	8	< 0.1%

Value	Count	Frequency (%)
1250	1	< 0.1%
1000	1	< 0.1%
750	1	< 0.1%
720	1	< 0.1%
600	1	< 0.1%
550	1	< 0.1%
540	1	< 0.1%
500	2	< 0.1%
450	1	< 0.1%
405	1	< 0.1%

UCPwithoutGST
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	19059
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	267.00547

Minimum	0
Maximum	431504
Zeros	3355
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	41.5 MiB

Quantile statistics

Minimum	0
5-th percentile	3.5
Q1	14.2
median	47.46
Q3	129.2725
95-th percentile	879.29
Maximum	431504
Range	431504
Interquartile range (IQR)	115.0725

Descriptive statistics

Standard deviation	1473.7664
Coefficient of variation (CV)	5.5196115
Kurtosis	9644.2363
Mean	267.00547
Median Absolute Deviation (MAD)	38.46
Skewness	63.877524
Sum	7.2602418 × 10⁸
Variance	2171987.5
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9.75	77539	2.9%
111	50399	1.9%
49.65	38699	1.4%
1.78	36130	1.3%
39	32875	1.2%
11	26733	1.0%
13.04	23206	0.9%
50	22718	0.8%
4.4	20404	0.8%
29.8	18120	0.7%
Other values (19049)	2372313	87.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3355	0.1%
0.01	160	< 0.1%
0.02	2	< 0.1%
0.04	5	< 0.1%
0.06	35	< 0.1%
0.07	4	< 0.1%
0.1	154	< 0.1%
0.11	7	< 0.1%
0.13	2	< 0.1%
0.14	2	< 0.1%

Value	Count	Frequency (%)
431504	1	< 0.1%
296879	6	< 0.1%
230999.99	6	< 0.1%
214678.53	2	< 0.1%
164026	1	< 0.1%
157800	15	< 0.1%
138297.6	1	< 0.1%
135000	2	< 0.1%
128000	13	< 0.1%
104517	2	< 0.1%

PurGSTPer
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	22
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.8100044

Minimum	0
Maximum	120
Zeros	2105336
Zeros (%)	77.4%
Negative	0
Negative (%)	0.0%
Memory size	41.5 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	12
Maximum	120
Range	120
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	5.6036392
Coefficient of variation (CV)	1.9941745
Kurtosis	5.0249423
Mean	2.8100044
Median Absolute Deviation (MAD)	0
Skewness	2.0252391
Sum	7640784
Variance	31.400772
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=22)

Value	Count	Frequency (%)
0	2105336	77.4%
12	480466	17.7%
5	59194	2.2%
24	33824	1.2%
18	31928	1.2%
10	4489	0.2%
36	3012	0.1%
48	512	< 0.1%
15	90	< 0.1%
20	72	< 0.1%
Other values (12)	213	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2105336	77.4%
5	59194	2.2%
10	4489	0.2%
12	480466	17.7%
15	90	< 0.1%
17	2	< 0.1%
18	31928	1.2%
20	72	< 0.1%
24	33824	1.2%
25	12	< 0.1%

Value	Count	Frequency (%)
120	2	< 0.1%
108	5	< 0.1%
96	3	< 0.1%
90	1	< 0.1%
84	3	< 0.1%
72	69	< 0.1%
60	31	< 0.1%
54	42	< 0.1%
48	512	< 0.1%
36	3012	0.1%

MRP
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	12954
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	497.4035

Minimum	0.02
Maximum	555416
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	41.5 MiB

Quantile statistics

Minimum	0.02
5-th percentile	5.34
Q1	29.06
median	80
Q3	299
95-th percentile	2465.1
Maximum	555416
Range	555415.98
Interquartile range (IQR)	269.94

Descriptive statistics

Standard deviation	2126.8404
Coefficient of variation (CV)	4.2758855
Kurtosis	6947.3743
Mean	497.4035
Median Absolute Deviation (MAD)	66.88
Skewness	50.221613
Sum	1.3525078 × 10⁹
Variance	4523450.2
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17.65	35047	1.3%
17.33	28422	1.0%
37.92	26496	1.0%
42	24567	0.9%
602.55	21229	0.8%
284	16805	0.6%
2.56	16488	0.6%
259	16409	0.6%
17.74	16311	0.6%
42.01	16311	0.6%
Other values (12944)	2501051	92.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.02	2	< 0.1%
0.05	8	< 0.1%
0.08	35	< 0.1%
0.11	4	< 0.1%
0.16	7	< 0.1%
0.2	2	< 0.1%
0.21	2	< 0.1%
0.24	6	< 0.1%
0.34	4	< 0.1%
0.35	1	< 0.1%

Value	Count	Frequency (%)
555416	1	< 0.1%
396725	6	< 0.1%
330000	6	< 0.1%
280000	2	< 0.1%
238999.99	2	< 0.1%
210400	6	< 0.1%
197250	9	< 0.1%
189000	2	< 0.1%
183000	1	< 0.1%
167370	1	< 0.1%

TotalCost
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	42297
Distinct (%)	1.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	495.12128

Minimum	0
Maximum	483284.48
Zeros	3358
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	41.5 MiB

Quantile statistics

Minimum	0
5-th percentile	6.85
Q1	27.24
median	87.17
Q3	248.64
95-th percentile	1816.16
Maximum	483284.48
Range	483284.48
Interquartile range (IQR)	221.4

Descriptive statistics

Standard deviation	2512.7929
Coefficient of variation (CV)	5.0751059
Kurtosis	3562.6036
Mean	495.12128
Median Absolute Deviation (MAD)	69.93
Skewness	39.502489
Sum	1.3463021 × 10⁹
Variance	6314128.4
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
43.68	30877	1.1%
21.84	27638	1.0%
10.92	25713	0.9%
12.32	19174	0.7%
55.61	18778	0.7%
248.64	16759	0.6%
32.76	16005	0.6%
124.32	15642	0.6%
111.22	14883	0.5%
24.64	14590	0.5%
Other values (42287)	2519077	92.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3358	0.1%
0.01	12	< 0.1%
0.02	14	< 0.1%
0.03	22	< 0.1%
0.04	32	< 0.1%
0.06	10	< 0.1%
0.07	38	< 0.1%
0.08	45	< 0.1%
0.09	2	< 0.1%
0.1	1	< 0.1%

Value	Count	Frequency (%)
483284.48	1	< 0.1%
401479.68	1	< 0.1%
376320	1	< 0.1%
363031.2	1	< 0.1%
353472	2	< 0.1%
332504.48	6	< 0.1%
301109.76	1	< 0.1%
292499.87	1	< 0.1%
263424	2	< 0.1%
258719.99	6	< 0.1%

TotalDiscount
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	13071
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8.5991873

Minimum	-662.56
Maximum	79999.2
Zeros	2321505
Zeros (%)	85.4%
Negative	61
Negative (%)	< 0.1%
Memory size	41.5 MiB

Quantile statistics

Minimum	-662.56
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	28.52
Maximum	79999.2
Range	80661.76
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	95.441009
Coefficient of variation (CV)	11.098841
Kurtosis	200970.97
Mean	8.5991873
Median Absolute Deviation (MAD)	0
Skewness	285.88113
Sum	23382360
Variance	9108.9862
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2321505	85.4%
13.8	2423	0.1%
10.5	2268	0.1%
142.5	2241	0.1%
14.9	1978	0.1%
3.09	1859	0.1%
23.9	1623	0.1%
19	1464	0.1%
24	1429	0.1%
11.95	1282	< 0.1%
Other values (13061)	381064	14.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-662.56	1	< 0.1%
-322.82	1	< 0.1%
-316.05	1	< 0.1%
-237.48	1	< 0.1%
-161.4	3	< 0.1%
-147.78	1	< 0.1%
-129.26	1	< 0.1%
-121.06	1	< 0.1%
-110.85	1	< 0.1%
-106.52	1	< 0.1%

Value	Count	Frequency (%)
79999.2	1	< 0.1%
39999.6	1	< 0.1%
34000	1	< 0.1%
18650.8	1	< 0.1%
14124	1	< 0.1%
13136.58	1	< 0.1%
12312	1	< 0.1%
11999.88	1	< 0.1%
11840.4	1	< 0.1%
11228.76	1	< 0.1%

NetSales
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	42009
Distinct (%)	1.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	793.11882

Minimum	-38.3
Maximum	555416
Zeros	269495
Zeros (%)	9.9%
Negative	3
Negative (%)	< 0.1%
Memory size	41.5 MiB

Quantile statistics

Minimum	-38.3
5-th percentile	0
Q1	31.5
median	108
Q3	414
95-th percentile	3490
Maximum	555416
Range	555454.3
Interquartile range (IQR)	382.5

Descriptive statistics

Standard deviation	3422.807
Coefficient of variation (CV)	4.3156296
Kurtosis	2533.9107
Mean	793.11882
Median Absolute Deviation (MAD)	97.54
Skewness	31.18779
Sum	2.1565979 × 10⁹
Variance	11715608
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	269495	9.9%
35.5	10251	0.4%
17.65	10221	0.4%
602.55	10086	0.4%
55.29	9769	0.4%
35.3	8094	0.3%
35	8045	0.3%
65	7795	0.3%
17.33	7310	0.3%
37.92	7228	0.3%
Other values (41999)	2370842	87.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-38.3	1	< 0.1%
-11.83	1	< 0.1%
-3.86	1	< 0.1%
0	269495	9.9%
0.02	1	< 0.1%
0.04	1	< 0.1%
0.08	31	< 0.1%
0.1	1	< 0.1%
0.14	1	< 0.1%
0.15	1	< 0.1%

Value	Count	Frequency (%)
555416	1	< 0.1%
524810	1	< 0.1%
508800	1	< 0.1%
456000	1	< 0.1%
430000	1	< 0.1%
420800	2	< 0.1%
418425	1	< 0.1%
396725	6	< 0.1%
381600	1	< 0.1%
380000	1	< 0.1%

ReturnMRP
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	11784
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	83.692677

Minimum	0
Maximum	238999.99
Zeros	2450236
Zeros (%)	90.1%
Negative	0
Negative (%)	0.0%
Memory size	41.5 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	122.81
Maximum	238999.99
Range	238999.99
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	935.54594
Coefficient of variation (CV)	11.178349
Kurtosis	4296.5919
Mean	83.692677
Median Absolute Deviation (MAD)	0
Skewness	42.286642
Sum	2.2757177 × 10⁸
Variance	875246.2
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2450236	90.1%
37.92	1996	0.1%
17.65	1864	0.1%
284	1811	0.1%
42	1782	0.1%
602.55	1776	0.1%
17.33	1533	0.1%
518	1523	0.1%
259	1456	0.1%
35.3	1454	0.1%
Other values (11774)	253705	9.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2450236	90.1%
0.9	2	< 0.1%
0.95	3	< 0.1%
0.96	11	< 0.1%
1	2	< 0.1%
1.06	10	< 0.1%
1.1	1	< 0.1%
1.17	3	< 0.1%
1.21	1	< 0.1%
1.27	4	< 0.1%

Value	Count	Frequency (%)
238999.99	1	< 0.1%
160801.2	1	< 0.1%
148820	1	< 0.1%
143980	1	< 0.1%
136548	1	< 0.1%
123200	1	< 0.1%
112920	1	< 0.1%
107985	1	< 0.1%
105930	1	< 0.1%
101320	1	< 0.1%

GenericName
Categorical

Distinct	2962
Distinct (%)	0.1%
Missing	151
Missing (%)	< 0.1%
Memory size	240.3 MiB

SODIUM CHLORIDE 0.9%	219097
PANTOPRAZOLE 40MG INJ	61812
MULTIPLE ELECTROLYTES 500ML IVF	60556
ONDANSETRON 2MG/ML	59346
PARACETAMOL 1GM IV INJ	55766
Other values (2957)	2262408

Length

Max length	287
Median length	224
Mean length	27.651424
Min length	4

Characters and Unicode

Total characters	75183806
Distinct characters	76
Distinct categories	11 ?
Distinct scripts	2 ?
Distinct blocks	3 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	138 ?
Unique (%)	< 0.1%

Sample

1st row	ESOMEPRAZOLE 20MG
2nd row	FENTANYL INJ 500MCG/10ML
3rd row	CALCIUM GLUCONATE
4th row	CHLORHEXIDINE GLUCONATE 0.2%W/V
5th row	DEXTROSE 5% W/V IV FLUID

Common Values

Value	Count	Frequency (%)
SODIUM CHLORIDE 0.9%	219097	8.1%
PANTOPRAZOLE 40MG INJ	61812	2.3%
MULTIPLE ELECTROLYTES 500ML IVF	60556	2.2%
ONDANSETRON 2MG/ML	59346	2.2%
PARACETAMOL 1GM IV INJ	55766	2.1%
WATER FOR INJECTION 10ML SOLUTION	54835	2.0%
LIGNOCAINE HYDROCHLORIDE 2% INJ	44678	1.6%
PIPERACILLIN 4GM+ TAZOBACTAM 500MG	44082	1.6%
SODIUM CHLORIDE IVF 100ML	37441	1.4%
ENOXAPARIN 40MG	34938	1.3%
Other values (2952)	2046434	75.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
inj	685650	6.4%
	633136	5.9%
chloride	428719	4.0%
sodium	408464	3.8%
tab	321515	3.0%
0.9	234731	2.2%
40mg	204112	1.9%
500mg	175076	1.6%
1gm	146629	1.4%
ivf	141227	1.3%
Other values (2858)	7388415	68.6%

Most occurring characters

Value	Count	Frequency (%)
	8069352	10.7%
I	5714572	7.6%
M	5100626	6.8%
E	4762437	6.3%
O	4384886	5.8%
A	4321909	5.7%
L	4159913	5.5%
N	3795551	5.0%
0	3189844	4.2%
T	3031757	4.0%
Other values (66)	28652959	38.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	57031467	75.9%
Space Separator	8070225	10.7%
Decimal Number	7631744	10.2%
Other Punctuation	1567847	2.1%
Math Symbol	769466	1.0%
Dash Punctuation	47122	0.1%
Lowercase Letter	35931	< 0.1%
Close Punctuation	12655	< 0.1%
Open Punctuation	12506	< 0.1%
Control	4816	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
I	5714572	10.0%
M	5100626	8.9%
E	4762437	8.4%
O	4384886	7.7%
A	4321909	7.6%
L	4159913	7.3%
N	3795551	6.7%
T	3031757	5.3%
R	2868123	5.0%
C	2760430	4.8%
Other values (16)	16131263	28.3%

Lowercase Letter

Value	Count	Frequency (%)
i	4558	12.7%
o	3238	9.0%
e	3151	8.8%
a	3065	8.5%
l	2496	6.9%
t	2089	5.8%
n	2014	5.6%
r	1935	5.4%
c	1890	5.3%
d	1821	5.1%
Other values (15)	9674	26.9%

Decimal Number

Value	Count	Frequency (%)
0	3189844	41.8%
5	1261350	16.5%
1	1106530	14.5%
2	784342	10.3%
4	395444	5.2%
9	297769	3.9%
3	243273	3.2%
6	177597	2.3%
7	101919	1.3%
8	73676	1.0%

Other Punctuation

Value	Count	Frequency (%)
.	617865	39.4%
%	509132	32.5%
/	420516	26.8%
,	18768	1.2%
&	1566	0.1%

Space Separator

Value	Count	Frequency (%)
	8069352	> 99.9%
	873	< 0.1%

Dash Punctuation

Value	Count	Frequency (%)
-	47073	99.9%
–	49	0.1%

Control

Value	Count	Frequency (%)
	3612	75.0%
	1204	25.0%

Math Symbol

Value	Count	Frequency (%)
+	769466	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	12655	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	12506	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	27	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	57067398	75.9%
Common	18116408	24.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
I	5714572	10.0%
M	5100626	8.9%
E	4762437	8.3%
O	4384886	7.7%
A	4321909	7.6%
L	4159913	7.3%
N	3795551	6.7%
T	3031757	5.3%
R	2868123	5.0%
C	2760430	4.8%
Other values (41)	16167194	28.3%

Common

Value	Count	Frequency (%)
	8069352	44.5%
0	3189844	17.6%
5	1261350	7.0%
1	1106530	6.1%
2	784342	4.3%
+	769466	4.2%
.	617865	3.4%
%	509132	2.8%
/	420516	2.3%
4	395444	2.2%
Other values (15)	992567	5.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	75182884	> 99.9%
None	873	< 0.1%
Punctuation	49	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	8069352	10.7%
I	5714572	7.6%
M	5100626	6.8%
E	4762437	6.3%
O	4384886	5.8%
A	4321909	5.7%
L	4159913	5.5%
N	3795551	5.0%
0	3189844	4.2%
T	3031757	4.0%
Other values (64)	28652037	38.1%

None

Value	Count	Frequency (%)
	873	100.0%

Punctuation

Value	Count	Frequency (%)
–	49	100.0%

Category
Categorical

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	181.5 MiB

DRUGS	2719136

Length

Max length	5
Median length	5
Mean length	5
Min length	5

Characters and Unicode

Total characters	13595680
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	DRUGS
2nd row	DRUGS
3rd row	DRUGS
4th row	DRUGS
5th row	DRUGS

Common Values

Value	Count	Frequency (%)
DRUGS	2719136	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
drugs	2719136	100.0%

Most occurring characters

Value	Count	Frequency (%)
D	2719136	20.0%
R	2719136	20.0%
U	2719136	20.0%
G	2719136	20.0%
S	2719136	20.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	13595680	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
D	2719136	20.0%
R	2719136	20.0%
U	2719136	20.0%
G	2719136	20.0%
S	2719136	20.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	13595680	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
D	2719136	20.0%
R	2719136	20.0%
U	2719136	20.0%
G	2719136	20.0%
S	2719136	20.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	13595680	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
D	2719136	20.0%
R	2719136	20.0%
U	2719136	20.0%
G	2719136	20.0%
S	2719136	20.0%

SubCategory
Categorical

Distinct	33
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	210.3 MiB

INJECTIONS	1183247
TABLETS & CAPSULES	670016
IV FLUIDS, ELECTROLYTES, TPN	468778
SYRUP & SUSPENSION	89640
OINTMENTS, CREAMS & GELS	69245
Other values (28)	238210

Length

Max length	28
Median length	25
Mean length	16.103007
Min length	3

Characters and Unicode

Total characters	43786265
Distinct characters	27
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	TABLETS & CAPSULES
2nd row	INJECTIONS
3rd row	INJECTIONS
4th row	LIQUIDS & SOLUTIONS
5th row	IV FLUIDS, ELECTROLYTES, TPN

Common Values

Value	Count	Frequency (%)
INJECTIONS	1183247	43.5%
TABLETS & CAPSULES	670016	24.6%
IV FLUIDS, ELECTROLYTES, TPN	468778	17.2%
SYRUP & SUSPENSION	89640	3.3%
OINTMENTS, CREAMS & GELS	69245	2.5%
INHALERS & RESPULES	64098	2.4%
LIQUIDS & SOLUTIONS	44421	1.6%
POWDER	40087	1.5%
NUTRITIONAL SUPPLEMENTS	29194	1.1%
VACCINE	18426	0.7%
Other values (23)	41984	1.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
injections	1183247	19.3%
	945655	15.5%
capsules	670016	11.0%
tablets	670016	11.0%
iv	468778	7.7%
fluids	468778	7.7%
electrolytes	468778	7.7%
tpn	468778	7.7%
syrup	89642	1.5%
suspension	89640	1.5%
Other values (39)	592847	9.7%

Most occurring characters

Value	Count	Frequency (%)
S	5162034	11.8%
E	4563368	10.4%
T	4216536	9.6%
I	3769067	8.6%
	3397039	7.8%
N	3373737	7.7%
L	3097037	7.1%
C	2431443	5.6%
O	2017651	4.6%
U	1540972	3.5%
Other values (17)	10217381	23.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	38436769	87.8%
Space Separator	3397039	7.8%
Other Punctuation	1952457	4.5%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
S	5162034	13.4%
E	4563368	11.9%
T	4216536	11.0%
I	3769067	9.8%
N	3373737	8.8%
L	3097037	8.1%
C	2431443	6.3%
O	2017651	5.2%
U	1540972	4.0%
A	1537619	4.0%
Other values (13)	6727305	17.5%

Other Punctuation

Value	Count	Frequency (%)
,	1006801	51.6%
&	945655	48.4%
.	1	< 0.1%

Space Separator

Value	Count	Frequency (%)
	3397039	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	38436769	87.8%
Common	5349496	12.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
S	5162034	13.4%
E	4563368	11.9%
T	4216536	11.0%
I	3769067	9.8%
N	3373737	8.8%
L	3097037	8.1%
C	2431443	6.3%
O	2017651	5.2%
U	1540972	4.0%
A	1537619	4.0%
Other values (13)	6727305	17.5%

Common

Value	Count	Frequency (%)
	3397039	63.5%
,	1006801	18.8%
&	945655	17.7%
.	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	43786265	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
S	5162034	11.8%
E	4563368	10.4%
T	4216536	9.6%
I	3769067	8.6%
	3397039	7.8%
N	3373737	7.7%
L	3097037	7.1%
C	2431443	5.6%
O	2017651	4.6%
U	1540972	3.5%
Other values (17)	10217381	23.3%

SubCategoryL3
Categorical

Distinct	36
Distinct (%)	< 0.1%
Missing	9617
Missing (%)	0.4%
Memory size	235.5 MiB

INTRAVENOUS & OTHER STERILE SOLUTIONS	570608
ANTI-INFECTIVES	366863
GASTROINTESTINAL & HEPATOBILIARY SYSTEM	343922
CARDIOVASCULAR & HEMATOPOIETIC SYSTEM	313090
CENTRAL NERVOUS SYSTEM	278159
Other values (31)	836877

Length

Max length	66
Median length	38
Mean length	25.988316
Min length	8

Characters and Unicode

Total characters	70415837
Distinct characters	35
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	GASTROINTESTINAL & HEPATOBILIARY SYSTEM
2nd row	CENTRAL NERVOUS SYSTEM
3rd row	INTRAVENOUS & OTHER STERILE SOLUTIONS
4th row	EAR & MOUTH/ THROAT
5th row	INTRAVENOUS & OTHER STERILE SOLUTIONS

Common Values

Value	Count	Frequency (%)
INTRAVENOUS & OTHER STERILE SOLUTIONS	570608	21.0%
ANTI-INFECTIVES	366863	13.5%
GASTROINTESTINAL & HEPATOBILIARY SYSTEM	343922	12.6%
CARDIOVASCULAR & HEMATOPOIETIC SYSTEM	313090	11.5%
CENTRAL NERVOUS SYSTEM	278159	10.2%
VITAMINS & MINERALS	142456	5.2%
RESPIRATORY SYSTEM	131322	4.8%
HORMONES	98809	3.6%
ANAESTHETICS	98699	3.6%
NUTRITION	87861	3.2%
Other values (26)	277730	10.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
	1430168	17.4%
system	1179223	14.4%
intravenous	570608	7.0%
other	570608	7.0%
sterile	570608	7.0%
solutions	570608	7.0%
anti-infectives	366863	4.5%
gastrointestinal	343931	4.2%
hepatobiliary	343922	4.2%
hematopoietic	313090	3.8%
Other values (55)	1940135	23.7%

Most occurring characters

Value	Count	Frequency (%)
T	7346663	10.4%
S	7131971	10.1%
E	6973523	9.9%
I	6197439	8.8%
	5490245	7.8%
O	5121720	7.3%
A	4680824	6.6%
N	4578334	6.5%
R	4456016	6.3%
L	2923223	4.2%
Other values (25)	15515879	22.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	63039964	89.5%
Space Separator	5490245	7.8%
Other Punctuation	1456921	2.1%
Dash Punctuation	428675	0.6%
Lowercase Letter	32	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
T	7346663	11.7%
S	7131971	11.3%
E	6973523	11.1%
I	6197439	9.8%
O	5121720	8.1%
A	4680824	7.4%
N	4578334	7.3%
R	4456016	7.1%
L	2923223	4.6%
M	2199189	3.5%
Other values (12)	11431062	18.1%

Lowercase Letter

Value	Count	Frequency (%)
y	4	12.5%
u	4	12.5%
r	4	12.5%
v	4	12.5%
e	4	12.5%
d	4	12.5%
i	4	12.5%
c	4	12.5%

Other Punctuation

Value	Count	Frequency (%)
&	1438965	98.8%
/	15525	1.1%
,	2431	0.2%

Space Separator

Value	Count	Frequency (%)
	5490245	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	428675	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	63039996	89.5%
Common	7375841	10.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
T	7346663	11.7%
S	7131971	11.3%
E	6973523	11.1%
I	6197439	9.8%
O	5121720	8.1%
A	4680824	7.4%
N	4578334	7.3%
R	4456016	7.1%
L	2923223	4.6%
M	2199189	3.5%
Other values (20)	11431094	18.1%

Common

Value	Count	Frequency (%)
	5490245	74.4%
&	1438965	19.5%
-	428675	5.8%
/	15525	0.2%
,	2431	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	70415837	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
T	7346663	10.4%
S	7131971	10.1%
E	6973523	9.9%
I	6197439	8.8%
	5490245	7.8%
O	5121720	7.3%
A	4680824	6.6%
N	4578334	6.5%
R	4456016	6.3%
L	2923223	4.2%
Other values (25)	15515879	22.0%

Bill_Month
Real number (ℝ)

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.4982656

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	41.5 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	7
Q3	10
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	7

Descriptive statistics

Standard deviation	3.585137
Coefficient of variation (CV)	0.55170675
Kurtosis	-1.307667
Mean	6.4982656
Median Absolute Deviation (MAD)	3
Skewness	-0.019958661
Sum	17669668
Variance	12.853207
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
1	261265	9.6%
2	260863	9.6%
12	251629	9.3%
10	241769	8.9%
9	235343	8.7%
11	232622	8.6%
3	220717	8.1%
8	217232	8.0%
5	213263	7.8%
4	198405	7.3%
Other values (2)	386028	14.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	261265	9.6%
2	260863	9.6%
3	220717	8.1%
4	198405	7.3%
5	213263	7.8%
6	189628	7.0%
7	196400	7.2%
8	217232	8.0%
9	235343	8.7%
10	241769	8.9%

Value	Count	Frequency (%)
12	251629	9.3%
11	232622	8.6%
10	241769	8.9%
9	235343	8.7%
8	217232	8.0%
7	196400	7.2%
6	189628	7.0%
5	213263	7.8%
4	198405	7.3%
3	220717	8.1%

Bill_Year
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	178.9 MiB

2022	900714
2021	732418
2020	464638
2019	420421
2023	200945

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	10876544
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2019
2nd row	2019
3rd row	2019
4th row	2019
5th row	2019

Common Values

Value	Count	Frequency (%)
2022	900714	33.1%
2021	732418	26.9%
2020	464638	17.1%
2019	420421	15.5%
2023	200945	7.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2022	900714	33.1%
2021	732418	26.9%
2020	464638	17.1%
2019	420421	15.5%
2023	200945	7.4%

Most occurring characters

Value	Count	Frequency (%)
2	5918565	54.4%
0	3183774	29.3%
1	1152839	10.6%
9	420421	3.9%
3	200945	1.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	10876544	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	5918565	54.4%
0	3183774	29.3%
1	1152839	10.6%
9	420421	3.9%
3	200945	1.8%

Most occurring scripts

Value	Count	Frequency (%)
Common	10876544	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	5918565	54.4%
0	3183774	29.3%
1	1152839	10.6%
9	420421	3.9%
3	200945	1.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10876544	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	5918565	54.4%
0	3183774	29.3%
1	1152839	10.6%
9	420421	3.9%
3	200945	1.8%

Bill_Day
Real number (ℝ)

Distinct	31
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.67448

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	41.5 MiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	8
median	16
Q3	23
95-th percentile	29
Maximum	31
Range	30
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	8.7520599
Coefficient of variation (CV)	0.55836367
Kurtosis	-1.189178
Mean	15.67448
Median Absolute Deviation (MAD)	8
Skewness	0.014145068
Sum	42621042
Variance	76.598553
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
7	92584	3.4%
21	92572	3.4%
9	92106	3.4%
17	91899	3.4%
16	91764	3.4%
18	91495	3.4%
11	91103	3.4%
13	91024	3.3%
4	91004	3.3%
6	90854	3.3%
Other values (21)	1802731	66.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	84785	3.1%
2	88102	3.2%
3	90689	3.3%
4	91004	3.3%
5	89504	3.3%
6	90854	3.3%
7	92584	3.4%
8	88500	3.3%
9	92106	3.4%
10	90010	3.3%

Value	Count	Frequency (%)
31	47915	1.8%
30	79981	2.9%
29	81163	3.0%
28	90501	3.3%
27	88561	3.3%
26	87346	3.2%
25	86727	3.2%
24	90253	3.3%
23	88994	3.3%
22	88566	3.3%

Bill_Week
Real number (ℝ)

Distinct	53
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	26.443931

Minimum	1
Maximum	53
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	41.5 MiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	12
median	27
Q3	40
95-th percentile	50
Maximum	53
Range	52
Interquartile range (IQR)	28

Descriptive statistics

Standard deviation	15.656445
Coefficient of variation (CV)	0.59206191
Kurtosis	-1.3079171
Mean	26.443931
Median Absolute Deviation (MAD)	14
Skewness	-0.0099876765
Sum	71904646
Variance	245.12426
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
8	66354	2.4%
9	65741	2.4%
5	65566	2.4%
7	65204	2.4%
4	62772	2.3%
6	62467	2.3%
50	60057	2.2%
49	59083	2.2%
51	58320	2.1%
2	57737	2.1%
Other values (43)	2095835	77.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	57075	2.1%
2	57737	2.1%
3	57620	2.1%
4	62772	2.3%
5	65566	2.4%
6	62467	2.3%
7	65204	2.4%
8	66354	2.4%
9	65741	2.4%
10	53133	2.0%

Value	Count	Frequency (%)
53	7256	0.3%
52	50637	1.9%
51	58320	2.1%
50	60057	2.2%
49	59083	2.2%
48	55518	2.0%
47	57001	2.1%
46	53979	2.0%
45	54066	2.0%
44	50013	1.8%

Auto

Heatmap
Table

	UHID	TQty	UCPwithoutGST	PurGSTPer	MRP	TotalCost	TotalDiscount	NetSales	ReturnMRP	Bill_Month	Bill_Day	Bill_Week	SalesType	PharmacyType	SpecialisationName	Department	IsFormulary	Formulary	SubCategory	SubCategoryL3	Bill_Year
UHID	1.000	0.015	-0.021	0.029	-0.014	-0.001	0.089	0.004	-0.011	0.037	0.001	0.032	0.038	0.143	0.199	0.112	0.087	0.070	0.028	0.040	0.678
TQty	0.015	1.000	-0.126	0.109	-0.113	0.188	0.113	0.450	-0.547	0.015	-0.005	0.014	0.029	0.033	0.008	0.041	0.000	0.004	0.038	0.025	0.015
UCPwithoutGST	-0.021	-0.126	1.000	0.044	0.954	0.890	0.097	0.698	-0.002	0.010	0.002	0.009	0.002	0.003	0.012	0.003	0.007	0.004	0.007	0.025	0.003
PurGSTPer	0.029	0.109	0.044	1.000	-0.021	0.083	0.758	0.080	-0.156	0.002	0.001	0.000	0.136	0.213	0.054	0.109	0.008	0.054	0.100	0.077	0.051
MRP	-0.014	-0.113	0.954	-0.021	1.000	0.855	0.036	0.727	0.019	0.009	0.002	0.009	0.003	0.003	0.011	0.006	0.008	0.004	0.007	0.028	0.003
TotalCost	-0.001	0.188	0.890	0.083	0.855	1.000	0.146	0.790	-0.005	0.012	-0.000	0.011	0.002	0.003	0.011	0.000	0.008	0.004	0.006	0.027	0.004
TotalDiscount	0.089	0.113	0.097	0.758	0.036	0.146	1.000	0.129	-0.136	0.002	0.001	-0.001	0.002	0.004	0.000	0.006	0.002	0.007	0.000	0.004	0.002
NetSales	0.004	0.450	0.698	0.080	0.727	0.790	0.129	1.000	-0.516	0.006	-0.000	0.006	0.004	0.004	0.011	0.003	0.011	0.004	0.017	0.028	0.004
ReturnMRP	-0.011	-0.547	-0.002	-0.156	0.019	-0.005	-0.136	-0.516	1.000	0.009	-0.001	0.007	0.019	0.004	0.000	0.003	0.004	0.008	0.003	0.008	0.003
Bill_Month	0.037	0.015	0.010	0.002	0.009	0.012	0.002	0.006	0.009	1.000	0.016	0.976	0.017	0.049	0.097	0.078	0.048	0.017	0.013	0.017	0.264
Bill_Day	0.001	-0.005	0.002	0.001	0.002	-0.000	0.001	-0.000	-0.001	0.016	1.000	0.078	0.006	0.009	0.023	0.010	0.008	0.003	0.004	0.005	0.036
Bill_Week	0.032	0.014	0.009	0.000	0.009	0.011	-0.001	0.006	0.007	0.976	0.078	1.000	0.016	0.047	0.096	0.074	0.048	0.018	0.014	0.017	0.260
SalesType	0.038	0.029	0.002	0.136	0.003	0.002	0.002	0.004	0.019	0.017	0.006	0.016	1.000	0.715	0.317	0.458	0.013	0.059	0.283	0.171	0.054
PharmacyType	0.143	0.033	0.003	0.213	0.003	0.003	0.004	0.004	0.004	0.049	0.009	0.047	0.715	1.000	0.366	0.661	0.000	0.088	0.428	0.254	0.094
SpecialisationName	0.199	0.008	0.012	0.054	0.011	0.011	0.000	0.011	0.000	0.097	0.023	0.096	0.317	0.366	1.000	0.285	0.121	0.088	0.138	0.162	0.265
Department	0.112	0.041	0.003	0.109	0.006	0.000	0.006	0.003	0.003	0.078	0.010	0.074	0.458	0.661	0.285	1.000	0.061	0.048	0.172	0.140	0.198
IsFormulary	0.087	0.000	0.007	0.008	0.008	0.008	0.002	0.011	0.004	0.048	0.008	0.048	0.013	0.000	0.121	0.061	1.000	1.000	0.146	0.191	0.058
Formulary	0.070	0.004	0.004	0.054	0.004	0.004	0.007	0.004	0.008	0.017	0.003	0.018	0.059	0.088	0.088	0.048	1.000	1.000	0.150	0.243	0.088
SubCategory	0.028	0.038	0.007	0.100	0.007	0.006	0.000	0.017	0.003	0.013	0.004	0.014	0.283	0.428	0.138	0.172	0.146	0.150	1.000	0.401	0.049
SubCategoryL3	0.040	0.025	0.025	0.077	0.028	0.027	0.004	0.028	0.008	0.017	0.005	0.017	0.171	0.254	0.162	0.140	0.191	0.243	0.401	1.000	0.057
Bill_Year	0.678	0.015	0.003	0.051	0.003	0.004	0.002	0.004	0.003	0.264	0.036	0.260	0.054	0.094	0.265	0.198	0.058	0.088	0.049	0.057	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	SalesType	UHID	PharmacyType	SpecialisationName	Department	BillNo	BillDate	ItemName	Item_Code	IsFormulary	Formulary	TQty	UCPwithoutGST	MRP	TotalCost	NetSales	GenericName	Category	SubCategory	SubCategoryL3	Bill_Month	Bill_Year	Bill_Day	Bill_Week
2	IP Dispense	1.201800e+10	IP	Liver Disease and Transplantation	MS IP Pharmacy	PDS19-08659	2019-01-30	NEKSIUM (ESOMEPRAZOLE) 20MG TAB 1x10 PFIZER	PH001036	Yes	P1	1	48.00	63.00	53.76	63.00	ESOMEPRAZOLE 20MG	DRUGS	TABLETS & CAPSULES	GASTROINTESTINAL & HEPATOBILIARY SYSTEM	1	2019	30	5
7	IP Dispense	1.201800e+10	IP	Liver Disease and Transplantation	MS IP Pharmacy	PDS19-08923	2019-01-31	FENSTUD (FENTANYL) 50MCG/10ML INJ RUSAN	PH001660	Yes	P2	3	69.00	230.70	231.84	692.10	FENTANYL INJ 500MCG/10ML	DRUGS	INJECTIONS	CENTRAL NERVOUS SYSTEM	1	2019	31	5
12	IP Dispense	1.201800e+10	IP	Liver Disease and Transplantation	MS IP Pharmacy	PDS19-08981	2019-01-31	CALCIUM GLUCONATE 10ML INJ 1X1 HINDU	PH000543	Yes	P1	5	4.00	5.82	22.40	29.10	CALCIUM GLUCONATE	DRUGS	INJECTIONS	INTRAVENOUS & OTHER STERILE SOLUTIONS	1	2019	31	5
13	IP Dispense	1.201800e+10	IP	Liver Disease and Transplantation	MS IP Pharmacy	PDS19-08981	2019-01-31	CLOHEX MOUTH WASH 150ML DR REDDYS	PH000604	Yes	P1	1	69.95	102.00	78.34	102.00	CHLORHEXIDINE GLUCONATE 0.2%W/V	DRUGS	LIQUIDS & SOLUTIONS	EAR & MOUTH/ THROAT	1	2019	31	5
14	IP Dispense	1.201800e+10	IP	Liver Disease and Transplantation	MS IP Pharmacy	PDS19-08981	2019-01-31	DEXTROSE 5% 500ML CLARIS	PH000564	Yes	P1	2	16.50	31.02	36.96	62.04	DEXTROSE 5% W/V IV FLUID	DRUGS	IV FLUIDS, ELECTROLYTES, TPN	INTRAVENOUS & OTHER STERILE SOLUTIONS	1	2019	31	5
16	IP Dispense	1.201800e+10	IP	Liver Disease and Transplantation	MS IP Pharmacy	PDS19-08981	2019-01-31	EFIPRES (EPHEDRINE) 1ML INJ NEON	PH000354	Yes	P1	1	21.95	28.00	24.58	28.00	EPHEDRINE 30MG	DRUGS	INJECTIONS	CARDIOVASCULAR & HEMATOPOIETIC SYSTEM	1	2019	31	5
17	IP Dispense	1.201800e+10	IP	Liver Disease and Transplantation	MS IP Pharmacy	PDS19-08981	2019-01-31	FLEXBUMIN (HUMAN ALBUMIN) 20% 100ML INJ BAXTER	PH000401	No	NaN	2	3804.00	4765.00	7988.40	9530.00	HUMAN ALBUMIN 20% INJ	DRUGS	INJECTIONS	INTRAVENOUS & OTHER STERILE SOLUTIONS	1	2019	31	5
21	IP Dispense	1.201800e+10	IP	Liver Disease and Transplantation	MS IP Pharmacy	PDS19-08981	2019-01-31	HAEMACCEL 500ML ABBOTT	PH000560	Yes	P1	4	273.57	383.00	1225.59	1532.00	SODIUM CHLORIDE 0.85G + POTASSIUM CHLORIDE 0.038G + CALCIUM CHLORIDE 0.070G	DRUGS	IV FLUIDS, ELECTROLYTES, TPN	INTRAVENOUS & OTHER STERILE SOLUTIONS	1	2019	31	5
23	IP Dispense	1.201800e+10	IP	Liver Disease and Transplantation	MS IP Pharmacy	PDS19-08981	2019-01-31	HUMAN ALBUMIN 5% 250ML INJ BAXTER	PH000402	Yes	P1	2	2700.00	3054.00	5670.00	6108.00	HUMAN ALBUMIN 5% 250ML INJ	DRUGS	INJECTIONS	INTRAVENOUS & OTHER STERILE SOLUTIONS	1	2019	31	5
24	IP Dispense	1.201800e+10	IP	Liver Disease and Transplantation	MS IP Pharmacy	PDS19-08981	2019-01-31	KABILYTE (MULTIPLE ELECTROLYTES) 500ML FLEXBAG FRESENIUS	PH000561	Yes	P1	4	124.32	196.90	556.95	787.60	MULTIPLE ELECTROLYTES 500ML IVF	DRUGS	IV FLUIDS, ELECTROLYTES, TPN	INTRAVENOUS & OTHER STERILE SOLUTIONS	1	2019	31	5

	SalesType	UHID	PharmacyType	SpecialisationName	Department	BillNo	BillDate	ItemName	Item_Code	IsFormulary	Formulary	TQty	UCPwithoutGST	PurGSTPer	MRP	TotalCost	ReturnMRP	GenericName	Category	SubCategory	SubCategoryL3	Bill_Month	Bill_Year	Bill_Day	Bill_Week
5643249	OTC Return	NaN	OTC	Urology	NaN	SLR22-144571	2022-09-14	VSL 3 (LACTIC ACID BACTERIA+BIFIDOBACTERIA) CAP 1x10 SUN PHARMA	PH001697	Yes	P1	-2	273.47	12	403.00	612.57	725.40	LACTIC ACID BACTERIA + BIFIDOBACTERIA CAP	DRUGS	TABLETS & CAPSULES	GASTROINTESTINAL & HEPATOBILIARY SYSTEM	9	2022	14	37
5643250	OTC Return	NaN	OTC	Urology	NaN	SLR22-146778	2022-09-17	CRANPAC-D (CRANBERRY AND D-MANNOSE) TAB 1X10S IPCA	PH003483	Yes	P1	-3	235.09	18	365.00	832.22	985.50	CRANBERRY AND D-MANNOSE	DRUGS	TABLETS & CAPSULES	NUTRITION	9	2022	17	37
5643251	OTC Return	NaN	OTC	Urology	NaN	SLR22-146778	2022-09-17	EVALON (ESTRIOL) 15GM CREAM MSD	PH002315	Yes	P1	-1	314.11	12	462.90	351.80	416.61	ESTRIOL 1MG	DRUGS	OINTMENTS, CREAMS & GELS	HORMONES	9	2022	17	37
5643252	OTC Return	NaN	OTC	Urology	NaN	SLR22-146778	2022-09-17	MARTIFUR (NITROFURANTOIN) 100MG TAB 1x14 WALTER	PH001174	No	NaN	-2	56.70	12	79.57	127.01	143.22	NITROFURANTOIN 100MG TAB	DRUGS	TABLETS & CAPSULES	ANTI-INFECTIVES	9	2022	17	37
5643253	OTC Return	NaN	OTC	Urology	NaN	SLR22-58568	2022-04-26	PEGMOVE (POLYETHYLENE GLYCOL) 119GM POW SUN PHARMA	PH002730	Yes	P1	-2	153.60	12	224.00	344.06	403.20	POLYETHYLENE GLYCOL POWDER	DRUGS	POWDER	GASTROINTESTINAL & HEPATOBILIARY SYSTEM	4	2022	26	17
5643254	OTC Return	NaN	OTC	Urology	NaN	SLR22-71319	2022-05-18	CRESTOR (ROSUVASTATIN) 10 MG TAB 1x30 ASTRAZENECA	PH002571	Yes	P1	-1	445.71	12	624.00	499.20	561.60	ROSUVASTATIN 10MG TAB	DRUGS	TABLETS & CAPSULES	CARDIOVASCULAR & HEMATOPOIETIC SYSTEM	5	2022	18	20
5643255	OTC Return	NaN	OTC	Urology	NaN	SLR22-71319	2022-05-18	FLAVEDON MR (TRIMETAZIDINE) TAB 1x10 SERDIA	PH001302	Yes	P1	-1	89.76	12	130.90	100.53	117.81	TRIMETAZIDINE 35MG	DRUGS	TABLETS & CAPSULES	CARDIOVASCULAR & HEMATOPOIETIC SYSTEM	5	2022	18	20
5643256	OTC Return	NaN	OTC	Urology	NaN	SLR22-84863	2022-06-10	ARG9 SACHET 5GM NOUVEAU MEDICAMENTS	PH002388	Yes	P1	-33	30.28	12	42.40	1119.15	1399.20	L-ARGININE 3GM + PROANTHOCYANIDINS 75MG/GM POWDER	DRUGS	POWDER	VITAMINS & MINERALS	6	2022	10	23
5643257	OTC Return	NaN	OTC	Urology	NaN	SLR22-94095	2022-06-26	UDILIV (URSODEOXYCHOLIC ACID) 300MG TAB 1x15 ABBOTT	PH000873	Yes	P1	-3	397.21	5	694.19	1251.21	1874.31	URSODEOXYCHOLIC ACID 300MG TAB	DRUGS	TABLETS & CAPSULES	GASTROINTESTINAL & HEPATOBILIARY SYSTEM	6	2022	26	25
5643258	OTC Return	NaN	OTC	Urology	NaN	SLR22-94095	2022-06-26	URIMAX D (TAMSULOZIN 0.4MG + DUTASTERIDE 0.5MG) TAB 1x10 CIPLA	PH000119	Yes	P1	-4	375.54	12	525.74	1682.42	1892.68	TAMSULOSIN 0.4MG + DUTASTERIDE 0.5MG TAB	DRUGS	TABLETS & CAPSULES	GENITO-URINARY SYSTEM	6	2022	26	25

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Other Punctuation

Dash Punctuation

Space Separator

Open Punctuation

Close Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Punctuation

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Dash Punctuation

Other Punctuation

Decimal Number

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Uppercase Letter

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common